create table Teacher
(
	FacultyID int				NOT NULL,
	FaculatyName char(20)		NOT NULL,
	FacultyEmail varchar(20)	NULL,
	FacultyMobile int			NOT NULL,
	FacultySalary decimal(16,2) NOT NULL
)

--All Column
insert into Teacher 
values (1,'Suman','suman@school.com',99999,150000.50)

--4 column
insert into Teacher (FacultyID, FaculatyName, FacultyMobile, FacultySalary)
						values (2,'Sudheer',55555,180000.50);

--3 Column
insert into Teacher (FacultyID, FaculatyName, FacultyMobile)
				values (3,		'Surya',		8888)



select * from Teacher;